from nmj.sqlite.base_item import DatabaseItem
from nmj.tools.ordereddict import OrderedDict


class DbVersion(DatabaseItem):
	TABLE = "DB_VERSION"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("VERSION", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class ScanDirs(DatabaseItem):
	TABLE = "SCAN_DIRS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("DIRECTORY", "TEXT"), ("NAME", "TEXT"), ("SCAN_TIME", "TEXT"), ("SIZE", "INTEGER"), ("CATEGORY", "INTEGER"), ("STATUS", "TEXT"), ("SEQUENCE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class ScanSystem(DatabaseItem):
	TABLE = "SCAN_SYSTEM"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("TYPE", "TEXT"), ("VALUE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class ContentProviders(DatabaseItem):
	TABLE = "CONTENT_PROVIDERS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("NAME", "TEXT"), ("DESCRIPTION", "TEXT"), ("CREATE_TIME", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class Photos(DatabaseItem):
	TABLE = "PHOTOS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("TITLE", "TEXT"), ("SEARCH_TITLE", "TEXT"), ("PATH", "TEXT"), ("SCAN_DIRS_ID", "INTEGER"), ("THUMBNAIL", "TEXT"), ("PREVIEW", "TEXT"), ("FORMAT", "TEXT"), ("WIDTH", "TEXT"), ("HEIGHT", "TEXT"), ("CAPTURE_TIME", "TEXT"), ("F_NUMBER", "TEXT"), ("SHUTTLE_SPEED", "TEXT"), ("FOCAL_LENGTH", "TEXT"), ("ISO_SPEED", "TEXT"), ("FLASH", "TEXT"), ("MODEL", "TEXT"), ("SIZE", "INTEGER"), ("CREATE_TIME", "TEXT"), ("UPDATE_STATE", "TEXT"), ("FILE_STATUS", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class PhotoAlbums(DatabaseItem):
	TABLE = "PHOTO_ALBUMS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("TITLE", "TEXT"), ("SEARCH_TITLE", "TEXT"), ("PATH", "TEXT"), ("TOTAL_ITEM", "INTEGER"), ("CREATE_TIME", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class PhotoAlbumsPhotos(DatabaseItem):
	TABLE = "PHOTO_ALBUMS_PHOTOS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("PHOTO_ALBUMS_ID", "INTEGER"), ("PHOTOS_ID", "INTEGER"), ("SEQUENCE", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class PhotoDate(DatabaseItem):
	TABLE = "PHOTO_DATE"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("CAPTURE_TIME", "TEXT"), ("TOTAL_ITEM", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class PhotoLastOpen(DatabaseItem):
	TABLE = "PHOTO_LAST_OPEN"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("PHOTOS_ID", "INTEGER"), ("CREATE_TIME", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class Songs(DatabaseItem):
	TABLE = "SONGS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("TITLE", "TEXT"), ("SEARCH_TITLE", "TEXT"), ("PATH", "TEXT"), ("SCAN_DIRS_ID", "INTEGER"), ("FOLDERS_ID", "INTEGER"), ("RUNTIME", "TEXT"), ("FORMAT", "TEXT"), ("LYRIC", "TEXT"), ("RATING", "INTEGER"), ("HASH", "TEXT"), ("SIZE", "INTEGER"), ("PLAY_COUNT", "INTEGER"), ("BIT_RATE", "TEXT"), ("TRACK_POSITION", "INTEGER"), ("RELEASE_DATE", "TEXT"), ("CREATE_TIME", "TEXT"), ("UPDATE_STATE", "TEXT"), ("FILE_STATUS", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongAlbums(DatabaseItem):
	TABLE = "SONG_ALBUMS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("TITLE", "TEXT"), ("LANGUAGE", "TEXT"), ("SEARCH_TITLE", "TEXT"), ("TOTAL_ITEM", "TEXT"), ("RELEASE_DATE", "TEXT"), ("UPDATE_STATE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongAlbumsSongs(DatabaseItem):
	TABLE = "SONG_ALBUMS_SONGS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("ALBUMS_ID", "INTEGER"), ("SONGS_ID", "INTEGER"), ("SEQUENCE", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongFolders(DatabaseItem):
	TABLE = "SONG_FOLDERS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("FOLDER", "TEXT"), ("TOTAL_ITEM", "TEXT"), ("PATH", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongGenresSongs(DatabaseItem):
	TABLE = "SONG_GENRES_SONGS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("SONGS_ID", "INTEGER"), ("GENRES_ID", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongGenres(DatabaseItem):
	TABLE = "SONG_GENRES"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("NAME", "TEXT"), ("DESCRIPTION", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongGenresSongAlbums(DatabaseItem):
	TABLE = "SONG_GENRES_SONG_ALBUMS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("ALBUMS_ID", "INTEGER"), ("GENRES_ID", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongGroupsSongAlbums(DatabaseItem):
	TABLE = "SONG_GROUPS_SONG_ALBUMS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("GROUPS_ID", "INTEGER"), ("ALBUMS_ID", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongGroups(DatabaseItem):
	TABLE = "SONG_GROUPS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("NAME", "TEXT"), ("LANGUAGE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongPls(DatabaseItem):
	TABLE = "SONG_PLS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("NAME", "TEXT"), ("PATH", "TEXT"), ("FORMAT", "TEXT"), ("SCAN_DIRS_ID", "INTEGER"), ("SIZE", "INTEGER"), ("TOTAL_ITEM", "TEXT"), ("CREATE_TIME", "TEXT"), ("UPDATE_STATE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongPlsItem(DatabaseItem):
	TABLE = "SONG_PLS_ITEM"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("PLS_ID", "INTEGER"), ("SONGS_ID", "INTEGER"), ("SEQUENCE", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongLastOpen(DatabaseItem):
	TABLE = "SONG_LAST_OPEN"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("SONGS_ID", "INTEGER"), ("CREATE_TIME", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongPersonsSongs(DatabaseItem):
	TABLE = "SONG_PERSONS_SONGS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("PERSONS_ID", "INTEGER"), ("SONGS_ID", "INTEGER"), ("PERSON_TYPE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongPersonsSongAlbums(DatabaseItem):
	TABLE = "SONG_PERSONS_SONG_ALBUMS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("PERSONS_ID", "INTEGER"), ("ALBUMS_ID", "INTEGER"), ("PERSON_TYPE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongPersons(DatabaseItem):
	TABLE = "SONG_PERSONS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("NAME", "TEXT"), ("POSTER", "TEXT"), ("THUMBNAIL", "TEXT"), ("BIOGRAPHY", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class SongAlbumPosters(DatabaseItem):
	TABLE = "SONG_ALBUM_POSTERS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("POSTER", "TEXT"), ("POSTER_HASH", "TEXT"), ("THUMBNAIL", "TEXT"), ("THUMBNAIL_HASH", "TEXT"), ("TYPE", "TEXT"), ("CREATE_TIME", "TEXT"), ("MODIFY_TIME", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class Shows(DatabaseItem):
	TABLE = "SHOWS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("TITLE", "TEXT"), ("SEARCH_TITLE", "TEXT"), ("LAST_PLAY_ITEM", "TEXT"), ("TOTAL_ITEM", "INTEGER"), ("YEAR", "TEXT"), ("RELEASE_DATE", "TEXT"), ("POSTERS_ID", "INTEGER"), ("RATING", "INTEGER"), ("RESOLUTION", "TEXT"), ("PARENTAL_CONTROL", "TEXT"), ("RUNTIME", "INTEGER"), ("CREATE_TIME", "TEXT"), ("TTID", "TEXT"), ("UPDATE_STATE", "TEXT"), ("TITLE_TYPE", "TEXT"), ("CONTENT_ID", "INTEGER"), ("CONTENT_TTID", "INTEGER"), ("THREE_D", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class ShowsGenres(DatabaseItem):
	TABLE = "SHOWS_GENRES"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("GENRES_ID", "INTEGER"), ("SHOWS_ID", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class ShowsKeywords(DatabaseItem):
	TABLE = "SHOWS_KEYWORDS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("KEYWORDS_ID", "INTEGER"), ("SHOWS_ID", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class ShowsPersons(DatabaseItem):
	TABLE = "SHOWS_PERSONS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("PERSONS_ID", "INTEGER"), ("SHOWS_ID", "INTEGER"), ("PERSON_TYPE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class ShowsVideos(DatabaseItem):
	TABLE = "SHOWS_VIDEOS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("SHOWS_ID", "INTEGER"), ("VIDEOS_ID", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class ShowGroups(DatabaseItem):
	TABLE = "SHOW_GROUPS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("NAME", "TEXT"), ("GROUP_TYPE", "TEXT"), ("LANGUAGE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class ShowGroupsShows(DatabaseItem):
	TABLE = "SHOW_GROUPS_SHOWS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("GROUPS_ID", "INTEGER"), ("SHOWS_ID", "INTEGER"), ("TITLE_TYPE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class Videos(DatabaseItem):
	TABLE = "VIDEOS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("PATH", "TEXT"), ("FILE_TYPE", "TEXT"), ("SCAN_DIRS_ID", "INTEGER"), ("CREATE_TIME", "TEXT"), ("UPDATE_STATE", "TEXT"), ("FILE_STATUS", "TEXT"), ("HASH", "TEXT"), ("SIZE", "INTEGER"), ("THREE_D", "INTEGER"), ("RESOLUTION", "TEXT"), ("PLAY_COUNT", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class VideoBookmarks(DatabaseItem):
	TABLE = "VIDEO_BOOKMARKS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("VIDEOS_ID", "INTEGER"), ("TITLE", "TEXT"), ("SEARCH_TITLE", "TEXT"), ("BOOKMARK_TIME", "INTEGER"), ("THUMBNAIL", "TEXT"), ("TYPE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class VideoSubtitles(DatabaseItem):
	TABLE = "VIDEO_SUBTITLES"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("VIDEOS_ID", "INTEGER"), ("FILE_NAME", "TEXT"), ("LANGUAGE", "TEXT"), ("SIZE", "INTEGER"), ("CREATE_TIME", "TEXT"), ("TYPE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class VideoGenres(DatabaseItem):
	TABLE = "VIDEO_GENRES"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("NAME", "TEXT"), ("DESCRIPTION", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class VideoPersons(DatabaseItem):
	TABLE = "VIDEO_PERSONS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("NAME", "TEXT"), ("POSTER", "TEXT"), ("THUMBNAIL", "TEXT"), ("BIOGRAPHY", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class VideoPosters(DatabaseItem):
	TABLE = "VIDEO_POSTERS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("POSTER", "TEXT"), ("POSTER_HASH", "TEXT"), ("THUMBNAIL", "TEXT"), ("THUMBNAIL_HASH", "TEXT"), ("WALLPAPER", "TEXT"), ("TYPE", "TEXT"), ("CREATE_TIME", "TEXT"), ("MODIFY_TIME", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class VideoProperties(DatabaseItem):
	TABLE = "VIDEO_PROPERTIES"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("RUNTIME", "INTEGER"), ("RESOLUTION", "TEXT"), ("WIDTH", "TEXT"), ("HEIGHT", "TEXT"), ("ASPECT_RATIO", "TEXT"), ("SYSTEM", "TEXT"), ("VIDEO_CODEC", "TEXT"), ("FPS", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class Episodes(DatabaseItem):
	TABLE = "EPISODES"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("EPISODE_ID", "INTEGER"), ("SERIES_ID", "INTEGER"), ("SEASON_ID", "INTEGER"), ("SEASON", "INTEGER"), ("EPISODE", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class Synopsises(DatabaseItem):
	TABLE = "SYNOPSISES"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("SUMMARY", "TEXT"), ("TAGLINE", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class TvLastOpen(DatabaseItem):
	TABLE = "TV_LAST_OPEN"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("VIDEOS_ID", "INTEGER"), ("CREATE_TIME", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class MovieLastOpen(DatabaseItem):
	TABLE = "MOVIE_LAST_OPEN"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("VIDEOS_ID", "INTEGER"), ("CREATE_TIME", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class Keywords(DatabaseItem):
	TABLE = "KEYWORDS"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("KEYWORD", "TEXT"), ("DESCRIPTION", "TEXT"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

class Favourites(DatabaseItem):
	TABLE = "FAVOURITES"
	FIELDS = OrderedDict(
		[("ID", "INTEGER"), ("TYPE", "TEXT"), ("MEDIA_ID", "INTEGER"), ("CUSTOM1", "TEXT"), ("CUSTOM2", "TEXT"), ("CUSTOM3", "TEXT"), ("CUSTOM4", "TEXT"), ("CUSTOM5", "TEXT")]
	)
	DEFAULTS = {}

ALL_TABLES = [
	DbVersion,
	ScanDirs,
	ScanSystem,
	ContentProviders,
	Photos,
	PhotoAlbums,
	PhotoAlbumsPhotos,
	PhotoDate,
	PhotoLastOpen,
	Songs,
	SongAlbums,
	SongAlbumsSongs,
	SongFolders,
	SongGenresSongs,
	SongGenres,
	SongGenresSongAlbums,
	SongGroupsSongAlbums,
	SongGroups,
	SongPls,
	SongPlsItem,
	SongLastOpen,
	SongPersonsSongs,
	SongPersonsSongAlbums,
	SongPersons,
	SongAlbumPosters,
	Shows,
	ShowsGenres,
	ShowsKeywords,
	ShowsPersons,
	ShowsVideos,
	ShowGroups,
	ShowGroupsShows,
	Videos,
	VideoBookmarks,
	VideoSubtitles,
	VideoGenres,
	VideoPersons,
	VideoPosters,
	VideoProperties,
	Episodes,
	Synopsises,
	TvLastOpen,
	MovieLastOpen,
	Keywords,
	Favourites
]
